﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Littlebeer.ConnectionStringHelper.OleDB.SqlServer
{
    public class OleDBSqlServerConnection
    {
        
        public static string Get(string server, string dataBase)
        {
            string result = string.Format(@"Provider=SQLOLEDB;Data Source={0};
                                        Initial Catalog={1};Integrated Security = SSPI;", server, dataBase);
            return result;

        }
        public static string Get(string server, string dataBase, string user, string password)
        {
            string result = string.Format("Provider=SQLOLEDB;Data Source={0};Initial Catalog={1};UserId={2};Password={3};"
, server, dataBase, user, password);
            return result;

        }
    }
    public enum OleDBConnectionType
    {
        SqlServer, Oracle, Access, Excel
    }
}
